﻿CREATE TABLE [dbo].[BookingService] (
    [Id]               INT          IDENTITY (1, 1) NOT NULL,
    [AirportCodeFrom]  VARCHAR (10) NULL,
    [AirportCodeTo]    VARCHAR (10) NULL,
    [BookingDate]      DATETIME     NOT NULL,
    [DepartureDate]    DATETIME     NULL,
    [ArrivalDate]      DATETIME     NULL,
    [ExpiredDayAmount] INT          NULL,
    [Status]           VARCHAR (50) NOT NULL,
    CONSTRAINT [PK_GiuCho] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_BookingService_Airport] FOREIGN KEY ([AirportCodeFrom]) REFERENCES [dbo].[Airport] ([AirportCode]),
    CONSTRAINT [FK_BookingService_Airport1] FOREIGN KEY ([AirportCodeTo]) REFERENCES [dbo].[Airport] ([AirportCode])
);

